﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="RSCRMClientDataset" targetNamespace="http://tempuri.org/RSCRMClientDataset.xsd" xmlns:mstns="http://tempuri.org/RSCRMClientDataset.xsd" xmlns="http://tempuri.org/RSCRMClientDataset.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ReadyServiceConnectionString" IsAppSettingsProperty="true" Modifier="Public" Name="ReadyServiceConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ReadyServiceConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="rs_tblClientTableAdapter" GeneratorDataComponentClassName="rs_tblClientTableAdapter" Name="rs_tblClient" UserDataComponentName="rs_tblClientTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReadyServiceConnectionString (Web.config)" DbObjectName="RSCRM.dbo.rs_tblClient" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetRSCRMClientDataByAgentID" GetMethodModifier="Public" GetMethodName="GetRSCRMClientDataByAgentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetRSCRMClientDataByAgentID" UserSourceName="GetRSCRMClientDataByAgentID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [rs_tblClient] WHERE (([ClientID] = @Original_ClientID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [rs_tblClient] ([AccountID], [AccountNumberField], [AccountStatus], [AccountType], [Active], [AgentID], [AnnualIncome], [AnnualReviewMonth], [AnnualStatement], [ApplicationDate], [Audit_CreateBy], [Audit_CreateDt], [Audit_UpdateBy], [Audit_UpdateDt], [BillingCity], [BillingCountry], [BillingState], [BillingStreet], [BillingZipCode], [CompanyID], [DeliveryReceipt], [DescriptionInfo], [Email], [Fax], [FirstName], [Industry], [IssueDate], [LastName], [MiddleName], [Mobile], [Note], [NumEmployees], [PersonalFinancialStrategy], [Phone], [ProductName], [Provider], [ShippingCity], [ShippingCountry], [ShippingState], [ShippingStreet], [ShippingZipCode], [Title]) VALUES (@AccountID, @AccountNumberField, @AccountStatus, @AccountType, @Active, @AgentID, @AnnualIncome, @AnnualReviewMonth, @AnnualStatement, @ApplicationDate, @Audit_CreateBy, @Audit_CreateDt, @Audit_UpdateBy, @Audit_UpdateDt, @BillingCity, @BillingCountry, @BillingState, @BillingStreet, @BillingZipCode, @CompanyID, @DeliveryReceipt, @DescriptionInfo, @Email, @Fax, @FirstName, @Industry, @IssueDate, @LastName, @MiddleName, @Mobile, @Note, @NumEmployees, @PersonalFinancialStrategy, @Phone, @ProductName, @Provider, @ShippingCity, @ShippingCountry, @ShippingState, @ShippingStreet, @ShippingZipCode, @Title)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountNumberField" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountNumberField" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AccountStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Active" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Active" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AnnualIncome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnualIncome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnualReviewMonth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnualReviewMonth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnualStatement" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnualStatement" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ApplicationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ApplicationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Audit_CreateBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Audit_CreateBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Audit_CreateDt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Audit_CreateDt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Audit_UpdateBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Audit_UpdateBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Audit_UpdateDt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Audit_UpdateDt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingCity" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingCountry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingCountry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingState" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingStreet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingStreet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingZipCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DeliveryReceipt" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DeliveryReceipt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescriptionInfo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptionInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Industry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Industry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@IssueDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="IssueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mobile" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumEmployees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumEmployees" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PersonalFinancialStrategy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PersonalFinancialStrategy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Provider" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Provider" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingCity" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingCountry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingCountry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingState" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingStreet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingStreet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingZipCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AccountID, AccountNumberField, AccountStatus, AccountType, Active, AgentID, AnnualIncome, AnnualReviewMonth, AnnualStatement, ApplicationDate, Audit_CreateBy, Audit_CreateDt, Audit_UpdateBy, Audit_UpdateDt, BillingCity, BillingCountry, BillingState, BillingStreet, BillingZipCode, ClientID, CompanyID, DeliveryReceipt, DescriptionInfo, Email, Fax, FirstName, Industry, IssueDate, LastName, MiddleName, Mobile, Note, NumEmployees, PersonalFinancialStrategy, Phone, ProductName, Provider, ShippingCity, ShippingCountry, ShippingState, ShippingStreet, ShippingZipCode, Title FROM rs_tblClient WHERE (CompanyID = @CompanyID) AND (AgentID = @AgentID) ORDER BY LastName, FirstName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CompanyID" ColumnName="CompanyID" DataSourceName="RSCRM.dbo.rs_tblClient" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AgentID" ColumnName="AgentID" DataSourceName="RSCRM.dbo.rs_tblClient" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AgentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [rs_tblClient] SET [AccountID] = @AccountID, [AccountNumberField] = @AccountNumberField, [AccountStatus] = @AccountStatus, [AccountType] = @AccountType, [Active] = @Active, [AgentID] = @AgentID, [AnnualIncome] = @AnnualIncome, [AnnualReviewMonth] = @AnnualReviewMonth, [AnnualStatement] = @AnnualStatement, [ApplicationDate] = @ApplicationDate, [Audit_CreateBy] = @Audit_CreateBy, [Audit_CreateDt] = @Audit_CreateDt, [Audit_UpdateBy] = @Audit_UpdateBy, [Audit_UpdateDt] = @Audit_UpdateDt, [BillingCity] = @BillingCity, [BillingCountry] = @BillingCountry, [BillingState] = @BillingState, [BillingStreet] = @BillingStreet, [BillingZipCode] = @BillingZipCode, [CompanyID] = @CompanyID, [DeliveryReceipt] = @DeliveryReceipt, [DescriptionInfo] = @DescriptionInfo, [Email] = @Email, [Fax] = @Fax, [FirstName] = @FirstName, [Industry] = @Industry, [IssueDate] = @IssueDate, [LastName] = @LastName, [MiddleName] = @MiddleName, [Mobile] = @Mobile, [Note] = @Note, [NumEmployees] = @NumEmployees, [PersonalFinancialStrategy] = @PersonalFinancialStrategy, [Phone] = @Phone, [ProductName] = @ProductName, [Provider] = @Provider, [ShippingCity] = @ShippingCity, [ShippingCountry] = @ShippingCountry, [ShippingState] = @ShippingState, [ShippingStreet] = @ShippingStreet, [ShippingZipCode] = @ShippingZipCode, [Title] = @Title WHERE (([ClientID] = @Original_ClientID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountNumberField" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountNumberField" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AccountStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Active" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Active" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AnnualIncome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnualIncome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnualReviewMonth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnualReviewMonth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnnualStatement" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnnualStatement" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ApplicationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ApplicationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Audit_CreateBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Audit_CreateBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Audit_CreateDt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Audit_CreateDt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Audit_UpdateBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Audit_UpdateBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Audit_UpdateDt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Audit_UpdateDt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingCity" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingCountry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingCountry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingState" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingStreet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingStreet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingZipCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DeliveryReceipt" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DeliveryReceipt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescriptionInfo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptionInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Industry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Industry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@IssueDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="IssueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mobile" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumEmployees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumEmployees" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PersonalFinancialStrategy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PersonalFinancialStrategy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Provider" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Provider" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingCity" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingCountry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingCountry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingState" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingStreet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingStreet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShippingZipCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShippingZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AccountID" DataSetColumn="AccountID" />
              <Mapping SourceColumn="AccountNumberField" DataSetColumn="AccountNumberField" />
              <Mapping SourceColumn="AccountStatus" DataSetColumn="AccountStatus" />
              <Mapping SourceColumn="AccountType" DataSetColumn="AccountType" />
              <Mapping SourceColumn="Active" DataSetColumn="Active" />
              <Mapping SourceColumn="AgentID" DataSetColumn="AgentID" />
              <Mapping SourceColumn="AnnualIncome" DataSetColumn="AnnualIncome" />
              <Mapping SourceColumn="AnnualReviewMonth" DataSetColumn="AnnualReviewMonth" />
              <Mapping SourceColumn="AnnualStatement" DataSetColumn="AnnualStatement" />
              <Mapping SourceColumn="ApplicationDate" DataSetColumn="ApplicationDate" />
              <Mapping SourceColumn="Audit_CreateBy" DataSetColumn="Audit_CreateBy" />
              <Mapping SourceColumn="Audit_CreateDt" DataSetColumn="Audit_CreateDt" />
              <Mapping SourceColumn="Audit_UpdateBy" DataSetColumn="Audit_UpdateBy" />
              <Mapping SourceColumn="Audit_UpdateDt" DataSetColumn="Audit_UpdateDt" />
              <Mapping SourceColumn="BillingCity" DataSetColumn="BillingCity" />
              <Mapping SourceColumn="BillingCountry" DataSetColumn="BillingCountry" />
              <Mapping SourceColumn="BillingState" DataSetColumn="BillingState" />
              <Mapping SourceColumn="BillingStreet" DataSetColumn="BillingStreet" />
              <Mapping SourceColumn="BillingZipCode" DataSetColumn="BillingZipCode" />
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
              <Mapping SourceColumn="CompanyID" DataSetColumn="CompanyID" />
              <Mapping SourceColumn="DeliveryReceipt" DataSetColumn="DeliveryReceipt" />
              <Mapping SourceColumn="DescriptionInfo" DataSetColumn="DescriptionInfo" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="Industry" DataSetColumn="Industry" />
              <Mapping SourceColumn="IssueDate" DataSetColumn="IssueDate" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="MiddleName" DataSetColumn="MiddleName" />
              <Mapping SourceColumn="Mobile" DataSetColumn="Mobile" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="NumEmployees" DataSetColumn="NumEmployees" />
              <Mapping SourceColumn="PersonalFinancialStrategy" DataSetColumn="PersonalFinancialStrategy" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="Provider" DataSetColumn="Provider" />
              <Mapping SourceColumn="ShippingCity" DataSetColumn="ShippingCity" />
              <Mapping SourceColumn="ShippingCountry" DataSetColumn="ShippingCountry" />
              <Mapping SourceColumn="ShippingState" DataSetColumn="ShippingState" />
              <Mapping SourceColumn="ShippingStreet" DataSetColumn="ShippingStreet" />
              <Mapping SourceColumn="ShippingZipCode" DataSetColumn="ShippingZipCode" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="RSCRMClientDataset" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="RSCRMClientDataset" msprop:Generator_UserDSName="RSCRMClientDataset">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="rs_tblClient" msprop:Generator_TableClassName="rs_tblClientDataTable" msprop:Generator_TableVarName="tablers_tblClient" msprop:Generator_TablePropName="rs_tblClient" msprop:Generator_RowDeletingName="rs_tblClientRowDeleting" msprop:Generator_UserTableName="rs_tblClient" msprop:Generator_RowChangingName="rs_tblClientRowChanging" msprop:Generator_RowEvHandlerName="rs_tblClientRowChangeEventHandler" msprop:Generator_RowDeletedName="rs_tblClientRowDeleted" msprop:Generator_RowEvArgName="rs_tblClientRowChangeEvent" msprop:Generator_RowChangedName="rs_tblClientRowChanged" msprop:Generator_RowClassName="rs_tblClientRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AccountID" msprop:Generator_ColumnVarNameInTable="columnAccountID" msprop:Generator_ColumnPropNameInRow="AccountID" msprop:Generator_ColumnPropNameInTable="AccountIDColumn" msprop:Generator_UserColumnName="AccountID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountNumberField" msprop:Generator_ColumnVarNameInTable="columnAccountNumberField" msprop:Generator_ColumnPropNameInRow="AccountNumberField" msprop:Generator_ColumnPropNameInTable="AccountNumberFieldColumn" msprop:Generator_UserColumnName="AccountNumberField" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountStatus" msprop:Generator_ColumnVarNameInTable="columnAccountStatus" msprop:Generator_ColumnPropNameInRow="AccountStatus" msprop:Generator_ColumnPropNameInTable="AccountStatusColumn" msprop:Generator_UserColumnName="AccountStatus" type="xs:int" minOccurs="0" />
              <xs:element name="AccountType" msprop:Generator_ColumnVarNameInTable="columnAccountType" msprop:Generator_ColumnPropNameInRow="AccountType" msprop:Generator_ColumnPropNameInTable="AccountTypeColumn" msprop:Generator_UserColumnName="AccountType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Active" msprop:Generator_ColumnVarNameInTable="columnActive" msprop:Generator_ColumnPropNameInRow="Active" msprop:Generator_ColumnPropNameInTable="ActiveColumn" msprop:Generator_UserColumnName="Active" type="xs:boolean" minOccurs="0" />
              <xs:element name="AgentID" msprop:Generator_ColumnVarNameInTable="columnAgentID" msprop:Generator_ColumnPropNameInRow="AgentID" msprop:Generator_ColumnPropNameInTable="AgentIDColumn" msprop:Generator_UserColumnName="AgentID" type="xs:int" minOccurs="0" />
              <xs:element name="AnnualIncome" msprop:Generator_ColumnVarNameInTable="columnAnnualIncome" msprop:Generator_ColumnPropNameInRow="AnnualIncome" msprop:Generator_ColumnPropNameInTable="AnnualIncomeColumn" msprop:Generator_UserColumnName="AnnualIncome" type="xs:int" minOccurs="0" />
              <xs:element name="AnnualReviewMonth" msprop:Generator_ColumnVarNameInTable="columnAnnualReviewMonth" msprop:Generator_ColumnPropNameInRow="AnnualReviewMonth" msprop:Generator_ColumnPropNameInTable="AnnualReviewMonthColumn" msprop:Generator_UserColumnName="AnnualReviewMonth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AnnualStatement" msprop:Generator_ColumnVarNameInTable="columnAnnualStatement" msprop:Generator_ColumnPropNameInRow="AnnualStatement" msprop:Generator_ColumnPropNameInTable="AnnualStatementColumn" msprop:Generator_UserColumnName="AnnualStatement" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ApplicationDate" msprop:Generator_ColumnVarNameInTable="columnApplicationDate" msprop:Generator_ColumnPropNameInRow="ApplicationDate" msprop:Generator_ColumnPropNameInTable="ApplicationDateColumn" msprop:Generator_UserColumnName="ApplicationDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Audit_CreateBy" msprop:Generator_ColumnVarNameInTable="columnAudit_CreateBy" msprop:Generator_ColumnPropNameInRow="Audit_CreateBy" msprop:Generator_ColumnPropNameInTable="Audit_CreateByColumn" msprop:Generator_UserColumnName="Audit_CreateBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Audit_CreateDt" msprop:Generator_ColumnVarNameInTable="columnAudit_CreateDt" msprop:Generator_ColumnPropNameInRow="Audit_CreateDt" msprop:Generator_ColumnPropNameInTable="Audit_CreateDtColumn" msprop:Generator_UserColumnName="Audit_CreateDt" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Audit_UpdateBy" msprop:Generator_ColumnVarNameInTable="columnAudit_UpdateBy" msprop:Generator_ColumnPropNameInRow="Audit_UpdateBy" msprop:Generator_ColumnPropNameInTable="Audit_UpdateByColumn" msprop:Generator_UserColumnName="Audit_UpdateBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Audit_UpdateDt" msprop:Generator_ColumnVarNameInTable="columnAudit_UpdateDt" msprop:Generator_ColumnPropNameInRow="Audit_UpdateDt" msprop:Generator_ColumnPropNameInTable="Audit_UpdateDtColumn" msprop:Generator_UserColumnName="Audit_UpdateDt" type="xs:dateTime" minOccurs="0" />
              <xs:element name="BillingCity" msprop:Generator_ColumnVarNameInTable="columnBillingCity" msprop:Generator_ColumnPropNameInRow="BillingCity" msprop:Generator_ColumnPropNameInTable="BillingCityColumn" msprop:Generator_UserColumnName="BillingCity" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingCountry" msprop:Generator_ColumnVarNameInTable="columnBillingCountry" msprop:Generator_ColumnPropNameInRow="BillingCountry" msprop:Generator_ColumnPropNameInTable="BillingCountryColumn" msprop:Generator_UserColumnName="BillingCountry" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingState" msprop:Generator_ColumnVarNameInTable="columnBillingState" msprop:Generator_ColumnPropNameInRow="BillingState" msprop:Generator_ColumnPropNameInTable="BillingStateColumn" msprop:Generator_UserColumnName="BillingState" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingStreet" msprop:Generator_ColumnVarNameInTable="columnBillingStreet" msprop:Generator_ColumnPropNameInRow="BillingStreet" msprop:Generator_ColumnPropNameInTable="BillingStreetColumn" msprop:Generator_UserColumnName="BillingStreet" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingZipCode" msprop:Generator_ColumnVarNameInTable="columnBillingZipCode" msprop:Generator_ColumnPropNameInRow="BillingZipCode" msprop:Generator_ColumnPropNameInTable="BillingZipCodeColumn" msprop:Generator_UserColumnName="BillingZipCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClientID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" msprop:Generator_UserColumnName="ClientID" type="xs:int" />
              <xs:element name="CompanyID" msprop:Generator_ColumnVarNameInTable="columnCompanyID" msprop:Generator_ColumnPropNameInRow="CompanyID" msprop:Generator_ColumnPropNameInTable="CompanyIDColumn" msprop:Generator_UserColumnName="CompanyID" type="xs:int" minOccurs="0" />
              <xs:element name="DeliveryReceipt" msprop:Generator_ColumnVarNameInTable="columnDeliveryReceipt" msprop:Generator_ColumnPropNameInRow="DeliveryReceipt" msprop:Generator_ColumnPropNameInTable="DeliveryReceiptColumn" msprop:Generator_UserColumnName="DeliveryReceipt" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DescriptionInfo" msprop:Generator_ColumnVarNameInTable="columnDescriptionInfo" msprop:Generator_ColumnPropNameInRow="DescriptionInfo" msprop:Generator_ColumnPropNameInTable="DescriptionInfoColumn" msprop:Generator_UserColumnName="DescriptionInfo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnPropNameInTable="FaxColumn" msprop:Generator_UserColumnName="Fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Industry" msprop:Generator_ColumnVarNameInTable="columnIndustry" msprop:Generator_ColumnPropNameInRow="Industry" msprop:Generator_ColumnPropNameInTable="IndustryColumn" msprop:Generator_UserColumnName="Industry" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IssueDate" msprop:Generator_ColumnVarNameInTable="columnIssueDate" msprop:Generator_ColumnPropNameInRow="IssueDate" msprop:Generator_ColumnPropNameInTable="IssueDateColumn" msprop:Generator_UserColumnName="IssueDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MiddleName" msprop:Generator_ColumnVarNameInTable="columnMiddleName" msprop:Generator_ColumnPropNameInRow="MiddleName" msprop:Generator_ColumnPropNameInTable="MiddleNameColumn" msprop:Generator_UserColumnName="MiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mobile" msprop:Generator_ColumnVarNameInTable="columnMobile" msprop:Generator_ColumnPropNameInRow="Mobile" msprop:Generator_ColumnPropNameInTable="MobileColumn" msprop:Generator_UserColumnName="Mobile" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumEmployees" msprop:Generator_ColumnVarNameInTable="columnNumEmployees" msprop:Generator_ColumnPropNameInRow="NumEmployees" msprop:Generator_ColumnPropNameInTable="NumEmployeesColumn" msprop:Generator_UserColumnName="NumEmployees" type="xs:int" minOccurs="0" />
              <xs:element name="PersonalFinancialStrategy" msprop:Generator_ColumnVarNameInTable="columnPersonalFinancialStrategy" msprop:Generator_ColumnPropNameInRow="PersonalFinancialStrategy" msprop:Generator_ColumnPropNameInTable="PersonalFinancialStrategyColumn" msprop:Generator_UserColumnName="PersonalFinancialStrategy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Provider" msprop:Generator_ColumnVarNameInTable="columnProvider" msprop:Generator_ColumnPropNameInRow="Provider" msprop:Generator_ColumnPropNameInTable="ProviderColumn" msprop:Generator_UserColumnName="Provider" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingCity" msprop:Generator_ColumnVarNameInTable="columnShippingCity" msprop:Generator_ColumnPropNameInRow="ShippingCity" msprop:Generator_ColumnPropNameInTable="ShippingCityColumn" msprop:Generator_UserColumnName="ShippingCity" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingCountry" msprop:Generator_ColumnVarNameInTable="columnShippingCountry" msprop:Generator_ColumnPropNameInRow="ShippingCountry" msprop:Generator_ColumnPropNameInTable="ShippingCountryColumn" msprop:Generator_UserColumnName="ShippingCountry" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingState" msprop:Generator_ColumnVarNameInTable="columnShippingState" msprop:Generator_ColumnPropNameInRow="ShippingState" msprop:Generator_ColumnPropNameInTable="ShippingStateColumn" msprop:Generator_UserColumnName="ShippingState" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingStreet" msprop:Generator_ColumnVarNameInTable="columnShippingStreet" msprop:Generator_ColumnPropNameInRow="ShippingStreet" msprop:Generator_ColumnPropNameInTable="ShippingStreetColumn" msprop:Generator_UserColumnName="ShippingStreet" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingZipCode" msprop:Generator_ColumnVarNameInTable="columnShippingZipCode" msprop:Generator_ColumnPropNameInRow="ShippingZipCode" msprop:Generator_ColumnPropNameInTable="ShippingZipCodeColumn" msprop:Generator_UserColumnName="ShippingZipCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:rs_tblClient" />
      <xs:field xpath="mstns:ClientID" />
    </xs:unique>
  </xs:element>
</xs:schema>